from random import sample, randint 
import pandas as pd
data_lastname = pd.read_excel(r'BaiJiaXing.xlsx',skiprows=1,usecols='B:i',header=None)
# print(data_lastname)
data_firstname = pd.read_excel(r'BaiJiaXing.xlsx',sheet_name='名',skiprows=1, usecols='b:k',header=None)
# print(data_firstname)


name_list = []
first_name = data_firstname.values
first = first_name[randint(0,29)][randint(0,9)]
last_name = data_lastname.values
last = last_name[randint(0,69)][randint(0,7)]
person = last + first
print(person)
# i = 0
# while i < 20:
#     person = ''.join(sample(data_firstname, 1) + sample(data_lastname, randint(1, 2)))
#     # sample重复，去重
#     if(person not in name_list):
#         name_list.append(person)
#         i += 1
# print(name_list)